import json

from openpyxl import load_workbook

# 1、打开工作簿
wb = load_workbook('testdata/excel_data.xlsx', read_only=True)
# 2、打开表
sh = wb['home']
# 3、读数据
c = sh.cell(row=4, column=2).value
print(c)

data = {
                "headers": "待定",
                "request_data": {"format": "json"},
            }
print(data,type(data))
new_data = json.dumps(data)

print(new_data)